Re: [GENERAL] primary key

At 16:35 +0200 on 9/9/98, Andrea Antibo wrote:


> CREATE TABLE films (
>        code      CHARACTER(5) CONSTRAINT firstkey PRIMARY KEY,
>        title     CHARACTER VARYING(40) NOT NULL,
>        did      DECIMAL(3) NOT NULL,
>        date_prod DATE,
>        kind     CHAR(10),
>        len       INTERVAL HOUR TO MINUTE     );
>
>
> but I have error near CONSTRAINT.
>
> Maybe this version of postgres can't accept the primary key?

True. No primary keys in 6.2.x. Just create a unique index on the code
field after creating the table (preferably, after loading data, if there is
any).

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma